CREATE PROCEDURE [dbo].[categories_update]
    @categoryId int,
    @name nvarchar(256)
AS
UPDATE [dbo].[Categories] SET     [dbo].[Categories].[Name] = @name
WHERE
    [dbo].[Categories].[CategoryId]=@categoryId
SELECT
    [CategoryId],
    [Name]
FROM [dbo].[Categories] 
WHERE
    Categories.[CategoryId]=@categoryId
RETURN 0
